mail.altrad.com/2015.02.mail.altrad.com.tar/mail.altrad.com/TEST/office deutch/ACCESS.NL-NL/ACCLR.CAB/ACCESS_TEMPLATE_SALESPIPELINE.ACCDT_1043/template/database/objects/queryCustomersExtended.txt

Text File | 2006-11-12 | 3KB | 92 lines

Operation =1
Option =0
Begin InputTables
    Name ="Customers"
End
Begin OutputColumns
    Alias ="Opslaan als"
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \", \" & [First Name]))"
    Alias ="Contactpersoon"
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & \" \" & [Last Name]))"
    Expression ="Customers.*"
End
Begin OrderBy
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \", \" & [First Name]))"
    Flag =0
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & \" \" & [Last Name]))"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbBoolean "FilterOnLoad" ="0"
dbBoolean "OrderByOnLoad" ="-1"
dbByte "RecordsetType" ="0"
dbBoolean "TotalsRow" ="0"
dbBinary "GUID" = Begin
    0x7233de6d5919c2438b87550d8a7eadfd
End
dbLongBinary "DOL" = Begin
    0x0acc0e5500000000235aaf10707214419ebd512cf4e2e3a800000000ae9675f4 ,
    0x570ae340010000004029283443007500730074006f006d006500720073000000 ,
    0x00000000932cc9c2567d2744be3cd96afe95a628070000007233de6d5919c243 ,
    0x8b87550d8a7eadfd460069006c00650020004100730000000000000065e7a973 ,
    0x69bcc04fbf9789799fc10c22070000007233de6d5919c2438b87550d8a7eadfd ,
    0x43006f006e00740061006300740020004e0061006d006500000000000000fee7 ,
    0x1c61aaa1ea4b914a720f56349c9707000000235aaf10707214419ebd512cf4e2 ,
    0xe3a84c0061007300740020004e0061006d00650000000000000075b48e87031a ,
    0x744c8ee79b351e3caaa607000000235aaf10707214419ebd512cf4e2e3a84600 ,
    0x690072007300740020004e0061006d006500000000000000698fb472ec924149 ,
    0xa6a0a58fbd19947307000000235aaf10707214419ebd512cf4e2e3a843006f00 ,
    0x6d00700061006e00790000000000000000000000000000000000000000000000 ,
    0x0c000000040000000000000000000000000000000000
End
Begin
    Begin
        dbText "Name" ="Contactpersoon"
        dbInteger "ColumnOrder" ="1"
        dbInteger "ColumnWidth" ="1695"
        dbBoolean "ColumnHidden" ="0"
        dbMemo "SmartTags" ="\"urn:schemas-microsoft-com:office:smarttags#PersonName\""
        dbLong "AggregateType" ="-1"
        dbBinary "GUID" = Begin
            0x65e7a97369bcc04fbf9789799fc10c22
        End
    End
    Begin
        dbText "Name" ="Opslaan als"
        dbInteger "ColumnWidth" ="1695"
        dbInteger "ColumnOrder" ="2"
        dbBoolean "ColumnHidden" ="0"
        dbLong "AggregateType" ="-1"
        dbBinary "GUID" = Begin
            0x932cc9c2567d2744be3cd96afe95a628
        End
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =799
    Bottom =612
    Left =-1
    Top =-1
    Right =784
    Bottom =268
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =48
        Top =12
        Right =192
        Bottom =156
        Top =0
        Name ="Customers"
        Name =""
    End
End